package jdbc;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class JdbcDemo07 {
    public static void main(String[] args) {
        userinfo userinfo = InputUtil.getInputObject(new userinfo(),"欢迎登录","登录");

        try (
                Connection connection = DbUtil.getConnection();
                ){
            String sql = "SELECT id,username,password,nickname,age " +
                          "FROM userinfo " +
                          "WHERE username = ? AND password  = ?";
            PreparedStatement ps = connection.prepareStatement(sql);
            ps.setString(1, userinfo.getUsername());
            ps.setString(2,userinfo.getPassword());
            ResultSet rs = ps.executeQuery();
            if (rs.next()){
                System.out.println("用户登录成功！ 欢迎你"+(rs.getString("nickname")));
            }else {
                System.out.println("用户登录失败，用户名或密码输入错误");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}
